2018-49-25

Background

Protocol Report

Table 15. Data and summary statistics for annual report

Appendix E: Template for Annual Terrestrial Vegetation Monitoring Report

Figures

  • Figure E1. Map showing locations of sites monitored in 20XX at [PARK].
  • Figure E2. Absolute foliar cover (%) of various plant groups observed during 20XX monitoring at [PARK].
  • Figure E3. Relative plant cover by nativity in plant communities at [PARK] observed during 20XX monitoring.
  • Figure E4. Relative plant cover by nativity and lifeform in plant communities at [PARK] observed during 20XX monitoring.
  • Figure E5. Absolute foliar cover of all species and of all native species for each of the last 6 years of monitoring at [PARK].
  • Figure E6. Density of native and non-native shrubs for each of the last 6 years of monitoring at [PARK].

Tables

  • Table E1. Potential [PARK] monitoring sites that were visited and rejected in 20XX. Table E.2. [PARK] monitoring sites installed in 20XX.
  • Table E3. [PARK] sites monitored in 20XX.
  • Table E4. [PARK] sites scheduled for monitoring, but not monitored in 20XX. Table E.5. Burned sites monitored at [PARK] in 20XX.
  • Table E6. Species richness (per transect) observed during 20XX monitoring of [PARK] vegetation.

Examples

Figure E1. Map of locations

Figure E1. Map of locations - clustered

Figure E2. Absolute foliar cover (%) - Static

Figure E2. Absolute foliar cover (%) - Dynamic

Table E6. Species by site

Table E6. Species richness by site - static

Site_Desc n_species
Anacapa Island 28
San Miguel Island 42
Santa Barbara Island 30
Santa Cruz Island 77
Santa Rosa Island 166

Database & Apps

MS Access DB on Windows

  • Fixed VBA errors with 32-bit Declare Function to 64-bit Private Declare PtrSafe Function using MS Access 2013

Windows only connection option:

library(RODBC)

accdb <- "Z:/bbest On My Mac/Google Drive/projects/nps-ecoquants/data/CHISLandVegetationMonitoringDatabase/LandVegetationMonitoring_DATA_be.accdb"

odbcDataSources()
db <- odbcConnectAccess2007(accdb)

sqlTables(db)
sqlQuery("SELECT * FROM tbl_Locations")

MS Access DB & Postgres

Create New Front-End App

Rmarkdown

Rmarkdown formats